﻿using System.Collections.Generic;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using NFLManager;
using NFLManager.Properties;

namespace NFLManagerTests
{
    /// <summary>
    /// test su ExcelClass
    /// </summary>
    [TestClass]
    public class tc_ExcelClass
    {
        //[TestMethod]
        //public void test_createDoc_openSheet()
        //{
        //    ExcelClass.createDoc(Settings.Default.DATA_PATH + Settings.Default.REPORT_FILE);
        //    ExcelClass.openSheet("WAS");
        //    ExcelClass.finalModifySaveAndClose();
        //}

        [TestMethod]
        public void test_writeXLS()
        {
            var dict = new Dictionary<string, string[,]>
                {
                    {"primo",new string[3,3]
                        {
                            {"a", "b", "c"},
                            {"d", "e", "f"},
                            {"g", "h", "i"}
                        }},
                    {"secondo",new string[2,7]
                    {
                        {"a", "b", "c","a", "b", "c","a"},
                        {"a", "b", "c","a", "b", "c","a"}
                    }},
                    {"terzo",new string[8,1]
                    {
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"}
                    }},
                    {"quarto",new string[7,1]
                    {
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"},
                        {"a"}
                    }},
                    {"quinto",new string[2,5]
                    {
                        {"a", "b", "c","a", "b"},
                        {"a", "b", "c","a", "b"}
                    }},
                    {"sesto",new string[2,2]
                    {
                        {"a", "b"},
                        {"a", "b"}
                    }}
                };
            //ExcelClass.createDoc(Settings.Default.DATA_PATH + Settings.Default.REPORT_FILE);
            //ExcelClass.openSheet("ATL");
            //ExcelClass.writeXLS(DataManager.createCompleteStatsTable(dict));
        }

    }
}
